﻿<%@ Page Title="" Language="C#" MasterPageFile="~/shop/MasterPage.master" AutoEventWireup="true" CodeFile="Statistics.aspx.cs" Inherits="admin_Statistics" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:Chart ID="Chart1" runat="server" CssClass="auto-style5" DataSourceID="SqlDataSource1">
        <Series>
            <asp:Series Name="Series1" XValueMember="商品名称" YValueMembers="Expr1">
            </asp:Series>
        </Series>
        <ChartAreas>
            <asp:ChartArea Name="ChartArea1">
            </asp:ChartArea>
        </ChartAreas>
    </asp:Chart>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:keshe2ConnectionString %>" SelectCommand="SELECT 商品.商品名称, SUM(订单.数量) AS Expr1 FROM 商品 INNER JOIN 订单 ON 商品.商品编号 = 订单.商品编号 GROUP BY 商品.商品名称"></asp:SqlDataSource>
</asp:Content>

